Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 7415 |
| Missing cells | 57 |
| Missing cells (%) | 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 753.2 KiB |
| Average record size in memory | 104.0 B |
Variable types
| Numeric | 11 |
|---|---|
| Text | 2 |
Proteins_Carbs_Ratio has 432 (5.8%) infinite values | Infinite |
Grams is highly skewed (γ1 = 21.86649389) | Skewed |
Fiber is highly skewed (γ1 = 29.65209972) | Skewed |
Unnamed: 0 is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
Protein has 265 (3.6%) zeros | Zeros |
Fat has 373 (5.0%) zeros | Zeros |
Sat.Fat has 508 (6.9%) zeros | Zeros |
Fiber has 1784 (24.1%) zeros | Zeros |
Carbs has 487 (6.6%) zeros | Zeros |
Proteins_per_gram has 265 (3.6%) zeros | Zeros |
Proteins_Carbs_Ratio has 210 (2.8%) zeros | Zeros |
Reproduction
| Analysis started | 2023-12-11 14:55:59.547318 |
|---|---|
| Analysis finished | 2023-12-11 14:56:24.242502 |
| Duration | 24.7 seconds |
| Software version | ydata-profiling vv4.6.3 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ)
UNIFORM UNIQUE
| Distinct | 7415 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3709.9496 |
| Minimum | 0 |
|---|---|
| Maximum | 7417 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 58.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 373.7 |
| Q1 | 1856.5 |
| median | 3710 |
| Q3 | 5563.5 |
| 95-th percentile | 7046.3 |
| Maximum | 7417 |
| Range | 7417 |
| Interquartile range (IQR) | 3707 |
Descriptive statistics
| Standard deviation | 2140.7561 |
|---|---|
| Coefficient of variation (CV) | 0.57703105 |
| Kurtosis | -1.1998264 |
| Mean | 3709.9496 |
| Median Absolute Deviation (MAD) | 1854 |
| Skewness | -0.00013310607 |
| Sum | 27509276 |
| Variance | 4582836.6 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 4956 | 1 | < 0.1% |
| 4954 | 1 | < 0.1% |
| 4953 | 1 | < 0.1% |
| 4952 | 1 | < 0.1% |
| 4951 | 1 | < 0.1% |
| 4950 | 1 | < 0.1% |
| 4949 | 1 | < 0.1% |
| 4948 | 1 | < 0.1% |
| 4947 | 1 | < 0.1% |
| Other values (7405) | 7405 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 7417 | 1 | |
| 7416 | 1 | |
| 7415 | 1 | |
| 7414 | 1 | |
| 7413 | 1 | |
| 7412 | 1 | |
| 7411 | 1 | |
| 7410 | 1 | |
| 7409 | 1 | |
| 7408 | 1 |
Food
Text
| Distinct | 7393 |
|---|---|
| Distinct (%) | 99.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 58.1 KiB |
Length
| Max length | 184 |
|---|---|
| Median length | 110 |
| Mean length | 38.651382 |
| Min length | 3 |
Characters and Unicode
| Total characters | 286600 |
|---|---|
| Distinct characters | 73 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 7373 ? |
|---|---|
| Unique (%) | 99.4% |
Sample
| 1st row | Cows' milk |
|---|---|
| 2nd row | Milk skim |
| 3rd row | Buttermilk |
| 4th row | Evaporated, undiluted |
| 5th row | Fortified milk |
| Value | Count | Frequency (%) |
| with | 2245 | 5.0% |
| or | 1543 | 3.4% |
| and | 1221 | 2.7% |
| fat | 1055 | 2.4% |
| added | 631 | 1.4% |
| sauce | 621 | 1.4% |
| cooked | 596 | 1.3% |
| as | 588 | 1.3% |
| to | 577 | 1.3% |
| ns | 561 | 1.3% |
| Other values (1890) | 35140 |
Most occurring characters
| Value | Count | Frequency (%) |
| 37381 | 13.0% | |
| e | 28894 | 10.1% |
| a | 22437 | 7.8% |
| o | 17602 | 6.1% |
| t | 17099 | 6.0% |
| r | 16261 | 5.7% |
| d | 13257 | 4.6% |
| i | 13218 | 4.6% |
| n | 12516 | 4.4% |
| , | 12432 | 4.3% |
| Other values (63) | 95503 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 222234 | |
| Space Separator | 37381 | 13.0% |
| Other Punctuation | 13145 | 4.6% |
| Uppercase Letter | 11556 | 4.0% |
| Dash Punctuation | 1137 | 0.4% |
| Open Punctuation | 447 | 0.2% |
| Close Punctuation | 447 | 0.2% |
| Decimal Number | 253 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 28894 | |
| a | 22437 | 10.1% |
| o | 17602 | 7.9% |
| t | 17099 | 7.7% |
| r | 16261 | 7.3% |
| d | 13257 | 6.0% |
| i | 13218 | 5.9% |
| n | 12516 | 5.6% |
| s | 10980 | 4.9% |
| c | 9494 | 4.3% |
| Other values (16) | 60476 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 1933 | |
| S | 1740 | |
| P | 1271 | |
| N | 970 | |
| B | 777 | 6.7% |
| F | 749 | 6.5% |
| M | 504 | 4.4% |
| R | 495 | 4.3% |
| T | 458 | 4.0% |
| G | 394 | 3.4% |
| Other values (16) | 2265 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 12432 | |
| / | 331 | 2.5% |
| ; | 186 | 1.4% |
| ' | 74 | 0.6% |
| % | 68 | 0.5% |
| " | 29 | 0.2% |
| . | 18 | 0.1% |
| & | 6 | < 0.1% |
| : | 1 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 109 | |
| 1 | 78 | |
| 2 | 41 | 16.2% |
| 5 | 10 | 4.0% |
| 4 | 7 | 2.8% |
| 3 | 5 | 2.0% |
| 9 | 2 | 0.8% |
| 7 | 1 | 0.4% |
Space Separator
| Value | Count | Frequency (%) |
| 37381 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1137 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 447 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 447 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 233790 | |
| Common | 52810 | 18.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 28894 | |
| a | 22437 | 9.6% |
| o | 17602 | 7.5% |
| t | 17099 | 7.3% |
| r | 16261 | 7.0% |
| d | 13257 | 5.7% |
| i | 13218 | 5.7% |
| n | 12516 | 5.4% |
| s | 10980 | 4.7% |
| c | 9494 | 4.1% |
| Other values (42) | 72032 |
Common
| Value | Count | Frequency (%) |
| 37381 | ||
| , | 12432 | 23.5% |
| - | 1137 | 2.2% |
| ( | 447 | 0.8% |
| ) | 447 | 0.8% |
| / | 331 | 0.6% |
| ; | 186 | 0.4% |
| 0 | 109 | 0.2% |
| 1 | 78 | 0.1% |
| ' | 74 | 0.1% |
| Other values (11) | 188 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 286600 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 37381 | 13.0% | |
| e | 28894 | 10.1% |
| a | 22437 | 7.8% |
| o | 17602 | 6.1% |
| t | 17099 | 6.0% |
| r | 16261 | 5.7% |
| d | 13257 | 4.6% |
| i | 13218 | 4.6% |
| n | 12516 | 4.4% |
| , | 12432 | 4.3% |
| Other values (63) | 95503 |
Grams
Real number (ℝ)
SKEWED
| Distinct | 103 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101.94889 |
| Minimum | 11 |
|---|---|
| Maximum | 1419 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 58.1 KiB |
Quantile statistics
| Minimum | 11 |
|---|---|
| 5-th percentile | 100 |
| Q1 | 100 |
| median | 100 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 1419 |
| Range | 1408 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 30.766728 |
|---|---|
| Coefficient of variation (CV) | 0.30178581 |
| Kurtosis | 720.95593 |
| Mean | 101.94889 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 21.866494 |
| Sum | 755951 |
| Variance | 946.59153 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 100 | 7120 | |
| 85 | 26 | 0.4% |
| 250 | 20 | 0.3% |
| 50 | 18 | 0.2% |
| 150 | 10 | 0.1% |
| 200 | 10 | 0.1% |
| 28 | 9 | 0.1% |
| 120 | 8 | 0.1% |
| 40 | 7 | 0.1% |
| 14 | 7 | 0.1% |
| Other values (93) | 180 | 2.4% |
| Value | Count | Frequency (%) |
| 11 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 14 | 7 | |
| 15 | 3 | < 0.1% |
| 16 | 1 | < 0.1% |
| 17 | 2 | < 0.1% |
| 20 | 5 | |
| 23 | 3 | < 0.1% |
| 25 | 3 | < 0.1% |
| 28 | 9 |
| Value | Count | Frequency (%) |
| 1419 | 1 | < 0.1% |
| 984 | 1 | < 0.1% |
| 976 | 1 | < 0.1% |
| 925 | 1 | < 0.1% |
| 540 | 1 | < 0.1% |
| 480 | 1 | < 0.1% |
| 454 | 2 | < 0.1% |
| 380 | 1 | < 0.1% |
| 346 | 6 | |
| 300 | 1 | < 0.1% |
Calories
Real number (ℝ)
| Distinct | 5527 |
|---|---|
| Distinct (%) | 74.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 198.95067 |
| Minimum | 0 |
|---|---|
| Maximum | 3969 |
| Zeros | 30 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 58.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 30.808 |
| Q1 | 81.94 |
| median | 163.95 |
| Q3 | 274.75 |
| 95-th percentile | 476.2 |
| Maximum | 3969 |
| Range | 3969 |
| Interquartile range (IQR) | 192.81 |
Descriptive statistics
| Standard deviation | 155.6334 |
|---|---|
| Coefficient of variation (CV) | 0.78227129 |
| Kurtosis | 52.249395 |
| Mean | 198.95067 |
| Median Absolute Deviation (MAD) | 93.51 |
| Skewness | 3.3699542 |
| Sum | 1475219.2 |
| Variance | 24221.755 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 30 | 0.4% |
| 65.33 | 20 | 0.3% |
| 900 | 16 | 0.2% |
| 66.53 | 16 | 0.2% |
| 65.54 | 16 | 0.2% |
| 66.41 | 15 | 0.2% |
| 205.26 | 13 | 0.2% |
| 177.67 | 11 | 0.1% |
| 66.04 | 11 | 0.1% |
| 327.3 | 10 | 0.1% |
| Other values (5517) | 7257 |
| Value | Count | Frequency (%) |
| 0 | 30 | |
| 0.32 | 1 | < 0.1% |
| 0.4 | 9 | 0.1% |
| 0.48 | 1 | < 0.1% |
| 0.52 | 1 | < 0.1% |
| 0.53 | 1 | < 0.1% |
| 0.54 | 1 | < 0.1% |
| 0.56 | 1 | < 0.1% |
| 0.6 | 1 | < 0.1% |
| 0.66 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 3969 | 1 | < 0.1% |
| 1963 | 2 | < 0.1% |
| 1210 | 1 | < 0.1% |
| 1207 | 1 | < 0.1% |
| 1182 | 1 | < 0.1% |
| 990 | 1 | < 0.1% |
| 900.26 | 1 | < 0.1% |
| 900 | 16 | |
| 899.73 | 1 | < 0.1% |
| 896.44 | 1 | < 0.1% |
Protein
Real number (ℝ)
ZEROS
| Distinct | 2118 |
|---|---|
| Distinct (%) | 28.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.5985597 |
| Minimum | -1 |
|---|---|
| Maximum | 232 |
| Zeros | 265 |
| Zeros (%) | 3.6% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 58.1 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 0.12 |
| Q1 | 2.12 |
| median | 6.04 |
| Q3 | 12.1 |
| 95-th percentile | 25.129 |
| Maximum | 232 |
| Range | 233 |
| Interquartile range (IQR) | 9.98 |
Descriptive statistics
| Standard deviation | 8.9385533 |
|---|---|
| Coefficient of variation (CV) | 1.0395408 |
| Kurtosis | 61.515451 |
| Mean | 8.5985597 |
| Median Absolute Deviation (MAD) | 4.45 |
| Skewness | 3.9636904 |
| Sum | 63758.32 |
| Variance | 79.897735 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 265 | 3.6% |
| 1 | 65 | 0.9% |
| 2 | 56 | 0.8% |
| 3 | 42 | 0.6% |
| 0.1 | 35 | 0.5% |
| 4 | 30 | 0.4% |
| 0.2 | 29 | 0.4% |
| 1.4 | 29 | 0.4% |
| 0.3 | 29 | 0.4% |
| 5 | 26 | 0.4% |
| Other values (2108) | 6809 |
| Value | Count | Frequency (%) |
| -1 | 1 | < 0.1% |
| 0 | 265 | |
| 0.01 | 3 | < 0.1% |
| 0.02 | 5 | 0.1% |
| 0.03 | 5 | 0.1% |
| 0.04 | 8 | 0.1% |
| 0.05 | 4 | 0.1% |
| 0.06 | 4 | 0.1% |
| 0.07 | 5 | 0.1% |
| 0.08 | 14 | 0.2% |
| Value | Count | Frequency (%) |
| 232 | 1 | |
| 114 | 2 | |
| 89 | 1 | |
| 78.13 | 2 | |
| 76.25 | 1 | |
| 66.67 | 1 | |
| 64.06 | 1 | |
| 62.82 | 2 | |
| 61.3 | 1 | |
| 58.94 | 1 |
Fat
Real number (ℝ)
ZEROS
| Distinct | 2113 |
|---|---|
| Distinct (%) | 28.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.9417181 |
| Minimum | 0 |
|---|---|
| Maximum | 233 |
| Zeros | 373 |
| Zeros (%) | 5.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 58.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.91 |
| median | 5.4 |
| Q3 | 12.54 |
| 95-th percentile | 27.775 |
| Maximum | 233 |
| Range | 233 |
| Interquartile range (IQR) | 10.63 |
Descriptive statistics
| Standard deviation | 11.587472 |
|---|---|
| Coefficient of variation (CV) | 1.2958888 |
| Kurtosis | 36.492601 |
| Mean | 8.9417181 |
| Median Absolute Deviation (MAD) | 4.62 |
| Skewness | 4.2298029 |
| Sum | 66302.84 |
| Variance | 134.26952 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 373 | 5.0% |
| 0.1 | 77 | 1.0% |
| 0.2 | 51 | 0.7% |
| 1 | 33 | 0.4% |
| 0.3 | 32 | 0.4% |
| 3.49 | 31 | 0.4% |
| 0.08 | 31 | 0.4% |
| 0.02 | 29 | 0.4% |
| 0.07 | 26 | 0.4% |
| 3.41 | 25 | 0.3% |
| Other values (2103) | 6707 |
| Value | Count | Frequency (%) |
| 0 | 373 | |
| 0.01 | 18 | 0.2% |
| 0.02 | 29 | 0.4% |
| 0.03 | 13 | 0.2% |
| 0.04 | 14 | 0.2% |
| 0.05 | 11 | 0.1% |
| 0.06 | 11 | 0.1% |
| 0.07 | 26 | 0.4% |
| 0.08 | 31 | 0.4% |
| 0.09 | 15 | 0.2% |
| Value | Count | Frequency (%) |
| 233 | 1 | < 0.1% |
| 115 | 2 | < 0.1% |
| 110 | 1 | < 0.1% |
| 100 | 16 | |
| 99.98 | 1 | < 0.1% |
| 99.97 | 1 | < 0.1% |
| 99.48 | 1 | < 0.1% |
| 99.1 | 1 | < 0.1% |
| 92.18 | 1 | < 0.1% |
| 91 | 1 | < 0.1% |
Sat.Fat
Real number (ℝ)
ZEROS
| Distinct | 3505 |
|---|---|
| Distinct (%) | 47.3% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9598288 |
| Minimum | 0 |
|---|---|
| Maximum | 234 |
| Zeros | 508 |
| Zeros (%) | 6.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 58.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.452 |
| median | 1.436 |
| Q3 | 3.726 |
| 95-th percentile | 10.0776 |
| Maximum | 234 |
| Range | 234 |
| Interquartile range (IQR) | 3.274 |
Descriptive statistics
| Standard deviation | 5.6575493 |
|---|---|
| Coefficient of variation (CV) | 1.9114448 |
| Kurtosis | 449.90668 |
| Mean | 2.9598288 |
| Median Absolute Deviation (MAD) | 1.322 |
| Skewness | 14.71713 |
| Sum | 21941.211 |
| Variance | 32.007864 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 508 | 6.9% |
| 0.002 | 40 | 0.5% |
| 0.4 | 19 | 0.3% |
| 0.014 | 18 | 0.2% |
| 0.009 | 18 | 0.2% |
| 1 | 18 | 0.2% |
| 0.02 | 17 | 0.2% |
| 1.429 | 17 | 0.2% |
| 0.018 | 17 | 0.2% |
| 1.24 | 16 | 0.2% |
| Other values (3495) | 6725 |
| Value | Count | Frequency (%) |
| 0 | 508 | |
| 0.001 | 9 | 0.1% |
| 0.002 | 40 | 0.5% |
| 0.003 | 10 | 0.1% |
| 0.004 | 8 | 0.1% |
| 0.005 | 9 | 0.1% |
| 0.006 | 12 | 0.2% |
| 0.007 | 5 | 0.1% |
| 0.008 | 14 | 0.2% |
| 0.009 | 18 | 0.2% |
| Value | Count | Frequency (%) |
| 234 | 1 | < 0.1% |
| 116 | 2 | |
| 92 | 1 | < 0.1% |
| 88 | 1 | < 0.1% |
| 82.5 | 1 | < 0.1% |
| 76 | 1 | < 0.1% |
| 61.924 | 1 | < 0.1% |
| 51.368 | 3 | |
| 46.24 | 1 | < 0.1% |
| 46.235 | 1 | < 0.1% |
Fiber
Real number (ℝ)
SKEWED ZEROS
| Distinct | 164 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.7342293 |
| Minimum | 0 |
|---|---|
| Maximum | 235 |
| Zeros | 1784 |
| Zeros (%) | 24.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 58.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.1 |
| median | 1 |
| Q3 | 2.1 |
| 95-th percentile | 6.2 |
| Maximum | 235 |
| Range | 235 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 4.2286466 |
|---|---|
| Coefficient of variation (CV) | 2.4383435 |
| Kurtosis | 1410.283 |
| Mean | 1.7342293 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 29.6521 |
| Sum | 12859.31 |
| Variance | 17.881452 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1784 | |
| 0.6 | 319 | 4.3% |
| 1 | 226 | 3.0% |
| 1.2 | 218 | 2.9% |
| 0.2 | 209 | 2.8% |
| 0.4 | 206 | 2.8% |
| 0.9 | 205 | 2.8% |
| 0.7 | 196 | 2.6% |
| 1.1 | 196 | 2.6% |
| 0.3 | 193 | 2.6% |
| Other values (154) | 3663 |
| Value | Count | Frequency (%) |
| 0 | 1784 | |
| 0.1 | 180 | 2.4% |
| 0.2 | 209 | 2.8% |
| 0.3 | 193 | 2.6% |
| 0.31 | 1 | < 0.1% |
| 0.4 | 206 | 2.8% |
| 0.5 | 145 | 2.0% |
| 0.6 | 319 | 4.3% |
| 0.7 | 196 | 2.6% |
| 0.8 | 188 | 2.5% |
| Value | Count | Frequency (%) |
| 235 | 1 | |
| 117 | 2 | |
| 67.5 | 1 | |
| 46.2 | 1 | |
| 42.8 | 1 | |
| 37.5 | 1 | |
| 37 | 1 | |
| 29.3 | 1 | |
| 27.3 | 2 | |
| 26.9 | 1 |
Carbs
Real number (ℝ)
ZEROS
| Distinct | 3151 |
|---|---|
| Distinct (%) | 42.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.020243 |
| Minimum | 0 |
|---|---|
| Maximum | 236 |
| Zeros | 487 |
| Zeros (%) | 6.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 58.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5.6 |
| median | 13.3 |
| Q3 | 26.46 |
| 95-th percentile | 71.823 |
| Maximum | 236 |
| Range | 236 |
| Interquartile range (IQR) | 20.86 |
Descriptive statistics
| Standard deviation | 22.718211 |
|---|---|
| Coefficient of variation (CV) | 1.0807778 |
| Kurtosis | 5.3970119 |
| Mean | 21.020243 |
| Median Absolute Deviation (MAD) | 9.17 |
| Skewness | 1.8709267 |
| Sum | 155865.1 |
| Variance | 516.11711 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 487 | 6.6% |
| 0.1 | 88 | 1.2% |
| 12.51 | 36 | 0.5% |
| 9.85 | 30 | 0.4% |
| 13.1 | 30 | 0.4% |
| 6.87 | 23 | 0.3% |
| 1 | 21 | 0.3% |
| 9.86 | 16 | 0.2% |
| 9 | 16 | 0.2% |
| 7.45 | 15 | 0.2% |
| Other values (3141) | 6653 |
| Value | Count | Frequency (%) |
| 0 | 487 | |
| 0.01 | 3 | < 0.1% |
| 0.03 | 2 | < 0.1% |
| 0.04 | 3 | < 0.1% |
| 0.05 | 2 | < 0.1% |
| 0.06 | 9 | 0.1% |
| 0.07 | 5 | 0.1% |
| 0.08 | 3 | < 0.1% |
| 0.09 | 12 | 0.2% |
| 0.1 | 88 | 1.2% |
| Value | Count | Frequency (%) |
| 236 | 1 | |
| 229 | 1 | |
| 216 | 1 | |
| 210 | 1 | |
| 199 | 1 | |
| 154 | 1 | |
| 150 | 1 | |
| 142 | 2 | |
| 134 | 1 | |
| 119 | 1 |
Category
Text
| Distinct | 2445 |
|---|---|
| Distinct (%) | 33.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 58.1 KiB |
Length
| Max length | 79 |
|---|---|
| Median length | 62 |
| Mean length | 14.131895 |
| Min length | 3 |
Characters and Unicode
| Total characters | 104788 |
|---|---|
| Distinct characters | 71 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1753 ? |
|---|---|
| Unique (%) | 23.6% |
Sample
| 1st row | Dairy products |
|---|---|
| 2nd row | Dairy products |
| 3rd row | Dairy products |
| 4th row | Dairy products |
| 5th row | Dairy products |
| Value | Count | Frequency (%) |
| or | 665 | 3.9% |
| with | 664 | 3.9% |
| and | 494 | 2.9% |
| chicken | 475 | 2.8% |
| sandwich | 297 | 1.8% |
| egg | 285 | 1.7% |
| rice | 271 | 1.6% |
| beef | 265 | 1.6% |
| vegetables | 235 | 1.4% |
| sauce | 234 | 1.4% |
| Other values (1347) | 13034 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 11121 | 10.6% |
| 9507 | 9.1% | |
| a | 8756 | 8.4% |
| r | 6564 | 6.3% |
| o | 6181 | 5.9% |
| t | 5957 | 5.7% |
| i | 5508 | 5.3% |
| s | 5415 | 5.2% |
| n | 4805 | 4.6% |
| l | 3792 | 3.6% |
| Other values (61) | 37182 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 85476 | |
| Space Separator | 9507 | 9.1% |
| Uppercase Letter | 8756 | 8.4% |
| Other Punctuation | 403 | 0.4% |
| Dash Punctuation | 266 | 0.3% |
| Open Punctuation | 185 | 0.2% |
| Close Punctuation | 181 | 0.2% |
| Decimal Number | 14 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 11121 | |
| a | 8756 | 10.2% |
| r | 6564 | 7.7% |
| o | 6181 | 7.2% |
| t | 5957 | 7.0% |
| i | 5508 | 6.4% |
| s | 5415 | 6.3% |
| n | 4805 | 5.6% |
| l | 3792 | 4.4% |
| c | 3789 | 4.4% |
| Other values (16) | 23588 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 1766 | |
| P | 1133 | |
| B | 775 | 8.9% |
| S | 743 | 8.5% |
| F | 574 | 6.6% |
| M | 451 | 5.2% |
| T | 411 | 4.7% |
| R | 365 | 4.2% |
| G | 300 | 3.4% |
| E | 271 | 3.1% |
| Other values (16) | 1967 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 272 | |
| ' | 62 | 15.4% |
| / | 37 | 9.2% |
| " | 22 | 5.5% |
| & | 6 | 1.5% |
| % | 2 | 0.5% |
| ; | 1 | 0.2% |
| : | 1 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4 | |
| 2 | 3 | |
| 3 | 2 | |
| 5 | 2 | |
| 1 | 1 | 7.1% |
| 9 | 1 | 7.1% |
| 7 | 1 | 7.1% |
Space Separator
| Value | Count | Frequency (%) |
| 9507 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 266 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 185 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 181 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 94232 | |
| Common | 10556 | 10.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 11121 | 11.8% |
| a | 8756 | 9.3% |
| r | 6564 | 7.0% |
| o | 6181 | 6.6% |
| t | 5957 | 6.3% |
| i | 5508 | 5.8% |
| s | 5415 | 5.7% |
| n | 4805 | 5.1% |
| l | 3792 | 4.0% |
| c | 3789 | 4.0% |
| Other values (42) | 32344 |
Common
| Value | Count | Frequency (%) |
| 9507 | ||
| , | 272 | 2.6% |
| - | 266 | 2.5% |
| ( | 185 | 1.8% |
| ) | 181 | 1.7% |
| ' | 62 | 0.6% |
| / | 37 | 0.4% |
| " | 22 | 0.2% |
| & | 6 | 0.1% |
| 0 | 4 | < 0.1% |
| Other values (9) | 14 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 104788 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 11121 | 10.6% |
| 9507 | 9.1% | |
| a | 8756 | 8.4% |
| r | 6564 | 6.3% |
| o | 6181 | 5.9% |
| t | 5957 | 5.7% |
| i | 5508 | 5.3% |
| s | 5415 | 5.2% |
| n | 4805 | 4.6% |
| l | 3792 | 3.6% |
| Other values (61) | 37182 |
Calorie_per_gram
Real number (ℝ)
| Distinct | 5630 |
|---|---|
| Distinct (%) | 75.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.9932234 |
| Minimum | 0 |
|---|---|
| Maximum | 17.526786 |
| Zeros | 30 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 58.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.3015 |
| Q1 | 0.8074 |
| median | 1.6434 |
| Q3 | 2.77205 |
| 95-th percentile | 4.80455 |
| Maximum | 17.526786 |
| Range | 17.526786 |
| Interquartile range (IQR) | 1.96465 |
Descriptive statistics
| Standard deviation | 1.5030449 |
|---|---|
| Coefficient of variation (CV) | 0.75407746 |
| Kurtosis | 5.9019842 |
| Mean | 1.9932234 |
| Median Absolute Deviation (MAD) | 0.9499 |
| Skewness | 1.5523425 |
| Sum | 14779.752 |
| Variance | 2.2591438 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 30 | 0.4% |
| 0.6533 | 20 | 0.3% |
| 9 | 20 | 0.3% |
| 0.6653 | 16 | 0.2% |
| 0.6554 | 16 | 0.2% |
| 0.6641 | 15 | 0.2% |
| 2.0526 | 13 | 0.2% |
| 1.7767 | 11 | 0.1% |
| 0.6604 | 11 | 0.1% |
| 3.273 | 10 | 0.1% |
| Other values (5620) | 7253 |
| Value | Count | Frequency (%) |
| 0 | 30 | |
| 0.0032 | 1 | < 0.1% |
| 0.004 | 9 | 0.1% |
| 0.0048 | 1 | < 0.1% |
| 0.0052 | 1 | < 0.1% |
| 0.0053 | 1 | < 0.1% |
| 0.0054 | 1 | < 0.1% |
| 0.0056 | 1 | < 0.1% |
| 0.006 | 1 | < 0.1% |
| 0.0066 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 17.52678571 | 2 | < 0.1% |
| 17.25652174 | 1 | < 0.1% |
| 9.0026 | 1 | < 0.1% |
| 9 | 20 | |
| 8.9973 | 1 | < 0.1% |
| 8.9644 | 1 | < 0.1% |
| 8.9526 | 1 | < 0.1% |
| 8.45 | 1 | < 0.1% |
| 8.3854 | 1 | < 0.1% |
| 7.8794 | 1 | < 0.1% |
Proteins_per_gram
Real number (ℝ)
ZEROS
| Distinct | 2237 |
|---|---|
| Distinct (%) | 30.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.085683165 |
| Minimum | -0.016666667 |
|---|---|
| Maximum | 1.0178571 |
| Zeros | 265 |
| Zeros (%) | 3.6% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 58.1 KiB |
Quantile statistics
| Minimum | -0.016666667 |
|---|---|
| 5-th percentile | 0.0012 |
| Q1 | 0.0213 |
| median | 0.0605 |
| Q3 | 0.12065 |
| 95-th percentile | 0.25293 |
| Maximum | 1.0178571 |
| Range | 1.0345238 |
| Interquartile range (IQR) | 0.09935 |
Descriptive statistics
| Standard deviation | 0.085390602 |
|---|---|
| Coefficient of variation (CV) | 0.99658552 |
| Kurtosis | 9.5294088 |
| Mean | 0.085683165 |
| Median Absolute Deviation (MAD) | 0.0446 |
| Skewness | 2.0334828 |
| Sum | 635.34067 |
| Variance | 0.0072915548 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 265 | 3.6% |
| 0.001 | 35 | 0.5% |
| 0.003 | 29 | 0.4% |
| 0.014 | 29 | 0.4% |
| 0.002 | 29 | 0.4% |
| 0.02 | 28 | 0.4% |
| 0.016 | 26 | 0.4% |
| 0.03 | 24 | 0.3% |
| 0.0138 | 23 | 0.3% |
| 0.008 | 19 | 0.3% |
| Other values (2227) | 6908 |
| Value | Count | Frequency (%) |
| -0.01666666667 | 1 | < 0.1% |
| 0 | 265 | |
| 0.0001 | 3 | < 0.1% |
| 0.0002 | 5 | 0.1% |
| 0.0003 | 5 | 0.1% |
| 0.0004 | 8 | 0.1% |
| 0.0005 | 4 | 0.1% |
| 0.0006 | 4 | 0.1% |
| 0.0007 | 5 | 0.1% |
| 0.0008 | 14 | 0.2% |
| Value | Count | Frequency (%) |
| 1.017857143 | 2 | |
| 1.008695652 | 1 | |
| 0.7813 | 2 | |
| 0.7625 | 1 | |
| 0.6667 | 1 | |
| 0.6406 | 1 | |
| 0.6282 | 2 | |
| 0.613 | 1 | |
| 0.5894 | 1 | |
| 0.5814 | 1 |
Proteins_Carbs_Ratio
Real number (ℝ)
INFINITE ZEROS
| Distinct | 5377 |
|---|---|
| Distinct (%) | 73.1% |
| Missing | 55 |
| Missing (%) | 0.7% |
| Infinite | 432 |
| Infinite (%) | 5.8% |
| Mean | inf |
| Minimum | -0.05 |
|---|---|
| Maximum | inf |
| Zeros | 210 |
| Zeros (%) | 2.8% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 58.1 KiB |
Quantile statistics
| Minimum | -0.05 |
|---|---|
| 5-th percentile | 0.018061532 |
| Q1 | 0.1198709 |
| median | 0.3142055 |
| Q3 | 1.0898038 |
| 95-th percentile | nan |
| Maximum | inf |
| Range | inf |
| Interquartile range (IQR) | 0.96993293 |
Descriptive statistics
| Standard deviation | nan |
|---|---|
| Coefficient of variation (CV) | nan |
| Kurtosis | nan |
| Mean | inf |
| Median Absolute Deviation (MAD) | 0.23689745 |
| Skewness | nan |
| Sum | inf |
| Variance | nan |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| inf | 432 | 5.8% |
| 0 | 210 | 2.8% |
| 0.1994177584 | 16 | 0.2% |
| 0.1986577181 | 15 | 0.2% |
| 1 | 14 | 0.2% |
| 0.3333333333 | 11 | 0.1% |
| 0.1938202247 | 11 | 0.1% |
| 0.189701897 | 10 | 0.1% |
| 0.2242090784 | 10 | 0.1% |
| 0.234769688 | 10 | 0.1% |
| Other values (5367) | 6621 | |
| (Missing) | 55 | 0.7% |
| Value | Count | Frequency (%) |
| -0.05 | 1 | < 0.1% |
| 0 | 210 | |
| 0.0003318584071 | 1 | < 0.1% |
| 0.0009094009321 | 1 | < 0.1% |
| 0.001009081736 | 1 | < 0.1% |
| 0.001117318436 | 1 | < 0.1% |
| 0.001154734411 | 1 | < 0.1% |
| 0.001178473222 | 1 | < 0.1% |
| 0.001217656012 | 1 | < 0.1% |
| 0.001221747098 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| inf | 432 | |
| 1700 | 1 | < 0.1% |
| 1163 | 2 | < 0.1% |
| 942.6666667 | 2 | < 0.1% |
| 687 | 1 | < 0.1% |
| 529.2 | 1 | < 0.1% |
| 382.6666667 | 6 | 0.1% |
| 374 | 2 | < 0.1% |
| 351.5714286 | 3 | < 0.1% |
| 323.6666667 | 6 | 0.1% |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| Unnamed: 0 | Food | Grams | Calories | Protein | Fat | Sat.Fat | Fiber | Carbs | Category | Calorie_per_gram | Proteins_per_gram | Proteins_Carbs_Ratio | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | Cows' milk | 976.0 | 680.0 | 32.0 | 40.0 | 36.0 | 0.0 | 48.0 | Dairy products | 0.696721 | 0.032787 | 0.666667 |
| 1 | 1 | Milk skim | 984.0 | 352.0 | 36.0 | 0.0 | 0.0 | 0.0 | 52.0 | Dairy products | 0.357724 | 0.036585 | 0.692308 |
| 2 | 2 | Buttermilk | 246.0 | 133.0 | 9.0 | 5.0 | 4.0 | 0.0 | 13.0 | Dairy products | 0.540650 | 0.036585 | 0.692308 |
| 3 | 3 | Evaporated, undiluted | 252.0 | 340.0 | 16.0 | 20.0 | 18.0 | 0.0 | 24.0 | Dairy products | 1.349206 | 0.063492 | 0.666667 |
| 4 | 4 | Fortified milk | 1419.0 | 1210.0 | 89.0 | 42.0 | 23.0 | 1.4 | 119.0 | Dairy products | 0.852713 | 0.062720 | 0.747899 |
| 5 | 5 | Powdered milk | 103.0 | 516.0 | 27.0 | 28.0 | 24.0 | 0.0 | 39.0 | Dairy products | 5.009709 | 0.262136 | 0.692308 |
| 6 | 6 | skim, instant | 85.0 | 288.0 | 30.0 | 0.0 | 0.0 | 0.0 | 42.0 | Dairy products | 3.388235 | 0.352941 | 0.714286 |
| 7 | 7 | skim, non-instant | 85.0 | 288.0 | 30.0 | 0.0 | 0.0 | 1.0 | 42.0 | Dairy products | 3.388235 | 0.352941 | 0.714286 |
| 8 | 8 | Goats' milk | 244.0 | 166.0 | 8.0 | 10.0 | 8.0 | 0.0 | 11.0 | Dairy products | 0.680328 | 0.032787 | 0.727273 |
| 9 | 9 | (1/2 cup ice cream) | 540.0 | 592.0 | 24.0 | 24.0 | 22.0 | 0.0 | 70.0 | Dairy products | 1.096296 | 0.044444 | 0.342857 |
| Unnamed: 0 | Food | Grams | Calories | Protein | Fat | Sat.Fat | Fiber | Carbs | Category | Calorie_per_gram | Proteins_per_gram | Proteins_Carbs_Ratio | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7405 | 7408 | Cauliflower, cooked, as ingredient | 100.0 | 31.33 | 2.00 | 0.29 | 0.135 | 2.1 | 5.18 | Cauliflower | 0.3133 | 0.0200 | 0.386100 |
| 7406 | 7409 | Eggplant, cooked, as ingredient | 100.0 | 31.19 | 1.05 | 0.19 | 0.037 | 3.2 | 6.32 | Eggplant | 0.3119 | 0.0105 | 0.166139 |
| 7407 | 7410 | Green beans, cooked, as ingredient | 100.0 | 38.75 | 1.91 | 0.23 | 0.052 | 2.8 | 7.26 | Green beans | 0.3875 | 0.0191 | 0.263085 |
| 7408 | 7411 | Summer squash, cooked, as ingredient | 100.0 | 24.83 | 1.31 | 0.35 | 0.104 | 1.2 | 4.11 | Summer squash | 0.2483 | 0.0131 | 0.318735 |
| 7409 | 7412 | Dark green vegetables as ingredient in omelet | 100.0 | 37.00 | 2.97 | 0.40 | 0.078 | 2.5 | 5.38 | Dark green vegetables as ingredient in omelet | 0.3700 | 0.0297 | 0.552045 |
| 7410 | 7413 | Tomatoes as ingredient in omelet | 100.0 | 28.43 | 1.11 | 0.23 | 0.038 | 1.6 | 5.48 | Tomatoes as ingredient in omelet | 0.2843 | 0.0111 | 0.202555 |
| 7411 | 7414 | Other vegetables as ingredient in omelet | 100.0 | 36.50 | 3.46 | 0.38 | 0.061 | 1.4 | 4.81 | Other vegetables as ingredient in omelet | 0.3650 | 0.0346 | 0.719335 |
| 7412 | 7415 | Vegetables as ingredient in curry | 100.0 | 55.35 | 1.81 | 0.19 | 0.051 | 2.2 | 11.60 | Vegetables as ingredient in curry | 0.5535 | 0.0181 | 0.156034 |
| 7413 | 7416 | Sauce as ingredient in hamburgers | 100.0 | 279.57 | 1.34 | 22.85 | 3.544 | 0.6 | 17.14 | Sauce as ingredient in hamburgers | 2.7957 | 0.0134 | 0.078180 |
| 7414 | 7417 | Industrial oil as ingredient in food | 100.0 | 900.00 | 0.00 | 100.00 | 32.672 | 0.0 | 0.00 | Industrial oil as ingredient in food | 9.0000 | 0.0000 | NaN |